package com.sc.nft.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sc.nft.entity.OrderSettle;
import com.sc.nft.enums.PayChannelEnum;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 结算单 Mapper 接口
 * </p>
 *
 * @author PC
 * @since 2024-10-22
 */
public interface ScOrderSettleMapper extends BaseMapper<OrderSettle> {


     List<OrderSettle> getUnsettleOrderBySandForUser();

     List<OrderSettle> getUnsettleOrderByLLForUser();

     @Select("SELECT * FROM `sc_order_settle` WHERE pay_channel=#{channel} AND `status`=0 and user_type='MERCHANT' and is_delete=0  LIMIT 500")
     List<OrderSettle> getSettleForPlat(@Param("channel") PayChannelEnum payChannelEnum);
}
